2016-01-04 - 26172 - Break fix - SNC Work Order Phase Master Creation #sncsup #SNCProject #MMPPSupport

2016-04-01 - 26172 - Break Fix - SNC Work Order Phase Master Creation


Problem Summary

SNC Work Order Phase Master Creation

Admin Info

Purpose
 SNC Work Order Phase Master Creation
Requested By
 Jingsha
Issue date Date
 04/01/2016
Resolved by
 Adithya, Prudvi
Resolved Date
 04/21/2016
Document Status
 Complete

Estimates

Sl.No
 Activity
 Estimation in Hours
1
 Research
 12
2
 Documentation
 8
3
 Development/ Config
 16
4
 Unit test in DEV
 12
5
 Unit test in QUA
6
 Other activity

TOTAL
 48

Detailed Problem Description

(Include Screen Shots if required )
Currently Phase Master which runs daily in SNC system needs a input file which gets generated in crystal. Phase Master data sometimes failed to get created due to timing and instability of Crystal report. We need to update the Phase Master creation program to generate date directly from SNC instead of reading a Crystal report.

Change the existing Program "ZPHASEMASTER" so as the program has to do pre processing and select the input data for the phase master.
Phase Master shall be created for the POs which are Created and Sent form ECC & Changed from ECC.
Phase Master shall be skipped for Updated/Changed in SNC.

Solution Analysis and Recommendations

[Discuss this section with Requester and get approval prior to beginning work]
Change the existing Program "ZPHASEMASTER" so as the program has to do pre processing and select the input data for the phase master.
Pre-processing shall go to table /1OM/ORDR1HDR100 and give the the date range as input and get the PO number Ids (ORDID) & Vendor (PRTIDFR)
1. Pos which are created (sent form ECC)
2. POs which are changed (Change sent from ECC only) are to be selected (Filter the changed records with PIAPPLUSER1 in Production)
Pass ORDID in to /1OM/ORDR2IT3100 get Product Id (MATID) Location Id - Plant (LOCIDTO) and Vendor Id (LOCIDFR)
Pass ORDID in to /1OM/ORDR7MP3100 get PO number and PO line item number, this is for the information that which PO the phase master shall be processed, this data shall be displayed in spool only.

Have all the data at one place:
Vendor Number - LOCIDFR From Table /1OM/ORDR2IT3100 or PRTIDFR from table /1OM/ORDR1HDR100.
Plant - LOCIDTO from Table /1OM/ORDR2IT3100
Material - MATID form Table /1OM/ORDR2IT3100

Data for above fields data are unconverted, Use FMs to convert the data in to numeric, and arrange the data as how it needs today.

VENDOR 0000VENDOR PLANT MATERIAL

Here is how current file looks like:
26172-4.JPG

After change Input screen looks like:
26172-1.JPG

Test Plan
[List test scenarios/cases to be executed here]
Test ID
 Test Scenario
 Expected Results
PHS01
 Background: Execute the Phase Master Program with input as Created/Changed Date having
1. New POs Created in ECC and Moved to SNC
2. POs changed in ECC and Moved to SNC
3. POs updated with new lines in ECC and Moved to SNC
4. Only PO Published in SNC.
5. Work Order created in SNC.
6. Confirmation updated in SNC.
7. Create ASN in SNC
 Job has to be executed successfully
1. Phase master shall be updated for the materials of the Purchase Orders.
2. Phase master shall be updated for the materials of the Purchase Orders.
3. Phase master shall be updated for the materials of the Purchase Orders.
4. Phase master shall not be updated for the materials of the Purchase Orders.
5. Phase master shall not be updated for the materials of the Purchase Orders
6. Phase master shall not be updated for the materials of the Purchase Orders
7. Phase master shall not be updated for the materials of the Purchase Orders
PHS02
 Foreground: Execute the Phase Master Program with input as Created/Changed Date having
1. New POs Created in ECC and Moved to SNC
2. POs changed in ECC and Moved to SNC
3. POs updated with new lines in ECC and Moved to SNC
4. Only PO Published in SNC.
5. Work Order created in SNC.
6. Confirmation updated in SNC.
7. Create ASN in SNC
 Job has to be executed successfully
1. Phase master shall be updated for the materials of the Purchase Orders.
2. Phase master shall be updated for the materials of the Purchase Orders.
3. Phase master shall be updated for the materials of the Purchase Orders.
4. Phase master shall not be updated for the materials of the Purchase Orders.
5. Phase master shall not be updated for the materials of the Purchase Orders
6. Phase master shall not be updated for the materials of the Purchase Orders
7. Phase master shall not be updated for the materials of the Purchase Orders

SNP on 04/22/2016
Checked the Phase Master Program job on 04/21/2016 and understand that phase master is skipped for few POs as the POs were changed before the Phase Master is executed.

26172-3.JPG

If we look at the above screen shot (highlighted in red) we understand that the create date & time are same as changed date and time for new POs, so change date and time was considered for both created and change in the program.
But we see that before the phase master program is executed there are changes updated with other user on the PO and those POs are getting skipped in the phase master.

New approach of logic:

1. Get the Created POs with the Input date.
2. Get the Changed POs with the same Input dates filter with the Input User ID.
3. Remove duplicates of combination of 1 & 2 and then Run Phase master for the POs rest of the data gathering is same.
Test ID
 Test Scenario
 Expected Results
PHS03
 Background: Execute the Phase Master Program with input as Created/Changed Date having
1. New POs created and moved to SNC.
2. New POs created and Published before the Phase master Job is executed.
3. POs changed in ECC and moved to SNC
4. POs updated with a new line in ECC and sent to SNC
5. Old PO Published in SNC
6. Created work orders for the old existing PO
7. Confirmations Updated for the work order of the existing PO.
 Job has to be executed successfully
1. Phase master shall be updated for the materials of the Purchase Orders.
2. Phase master shall be updated for the materials of the Purchase Orders.
3. Phase master shall be updated for the materials of the Purchase Orders.
4. Phase master shall be updated for the materials of the Purchase Orders.
5. Phase master shall not be updated for the materials of the Purchase Orders
6. Phase master shall not be updated for the materials of the Purchase Orders
7. Phase master shall not be updated for the materials of the Purchase Orders
04/27/2016:
Observed that supplier value is not updated for in tables /SCA/REWOCFG & /SCA/ASSIGN due to conversion did not happen in the program.
Work Orders were not getting created due to supplier missing in the phase master data.

Solution:
Change the program to have the conversion done and update the supplier value in the tables /SCA/REWOCFG & /SCA/ASSIGN
Also the records as such needs to be deleted from the tables /SCA/REWOCFG & /SCA/ASSIGN in SNP.

How ever the work orders are getting created. though it was having the entries with out the supplier.
Test ID
 Test Scenario
 Expected Results
PHAS01
 Run the phase master program with input date
 The Phase master shall be updated in the tables SCA/REWOCFG & /SCA/ASSIGN with supplier value
PHAS02
 Publish the PO for which the materials have the records with supplier empty in the field in table SCA/REWOCFG & /SCA/ASSIGN, Run the Work Order Job.
 The work orders shall be created, inspite of having the record for the same material with empty supplier value in the table SCA/REWOCFG & /SCA/ASSIGN
Resolution
[Provide complete technical details for configuration or programming here]
Carry out changes in program & schedule the job daily with date.
Carry out changes in the program for the new approach.


Release Information

[List Issues / Bugs identified in configuration or development]
2016-12-04 - 26172 - Rel Notes - SNC Work Order Phase Master Creation
2016-22-04 - 26172 - Rel Notes - SNC Work Order Phase Master Creation